YEAR(datenumber) WEEKDAY(datenumber) TODAY SECOND(datenumber) NOW MONTH(datenumber) MINUTE(datenumber) HOUR(datenumber) Day(datenumber) DATEVALUE(text) DATE(year,month,day) ADDTIME(datenumber,year,month,day,hour,minute)